-- created by kumiler
-- on 2022/11/28 13:42
-- DESC 

CREATE EXTERNAL TABLE spmi_ods.spmi_intercept_piece_exp
(
    id                 bigint COMMENT '自增ID',
    fee_id             bigint COMMENT '报价ID',
    begin_num          double COMMENT '条件表达式开始数字',
    end_num            double COMMENT '条件表达式结束数字',
    billing_condition  string COMMENT '计费条件',
    billing_expression string COMMENT '计算公式',
    billing_type       smallint COMMENT '计费类型1:W重量 2:P票数',
    sort               smallint COMMENT '排序'
)
    COMMENT '截留派费报价公式'
    PARTITIONED BY (dt string COMMENT '抽数日期(yyyy-MM-dd)')
    stored as parquet
    LOCATION '/dw/hive/spmi_ods.db/external/spmi_intercept_piece_exp'
;